﻿CREATE PROCEDURE [dbo].[EditAuctioneer]
	@id int,
	@username nvarchar(50),
	@firstname nvarchar(50),
	@lastname nvarchar(50),
	@password nvarchar(50),
	@rating decimal(18,1)
AS
	UPDATE Auctioneer
	SET Username = @username,
		FirstName = @firstname,
		LastName = @lastname,
		Password = @password,
		Rating = @rating
	WHERE Id = @id
RETURN 0
